---
title: "SQL-030: Retrieve vocational reserve service types"
summary: Retrieve vocational reserve service types
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Business.Claim
reference_type: embedded
---

# SQL-030 Retrieve vocational reserve service types

Retrieves vocational reserve service-cost codes joined to their description codes for the Vocational branch of the service-type collection.

## Classification



| Field | Value |
| --- | --- |
| **SQL ID** | SQL-030 |
| **Operation type** | Read |
| **Execution method** | Inline SQL (StringBuilder, Vocational branch) |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsServiceTypeCollection` |
| **Criteria property** | `SetRetrieveSQL(GetRetrieveSQL)` |
| **Lifecycle method** | `Criteria constructor → BeforeRetrieve` |

## Tables



| Table | Access | Columns used |
| --- | --- | --- |
| [CL_RESERVE_VOC_SERV_COST_CODE](../database-tables.md#cl_reserve_voc_serv_cost_code) | SELECT (JOIN) | CODE, CODE_DESCR |
| [CL_RESERVE_VOC_SERV_DESCR_CODE](../database-tables.md#cl_reserve_voc_serv_descr_code) | SELECT (JOIN) | RESERVE_VOC_SERV_COST_CODE, CODE, CODE_DESCR |

## Sample SQL

```sql
-- Retrieve vocational reserve service types (Vocational branch)
SELECT C.CODE        AS ServiceTypeCode,
       C.CODE_DESCR  AS ServiceTypeDescription,
       R.CODE        AS ServiceDescriptionCode,
       R.CODE_DESCR  AS ServiceDescription
  FROM CL_RESERVE_VOC_SERV_COST_CODE C
  LEFT OUTER JOIN CL_RESERVE_VOC_SERV_DESCR_CODE r
    ON R.RESERVE_VOC_SERV_COST_CODE = C.CODE
 ORDER BY ServiceTypeDescription, ServiceDescription
```

## Sources
- SAIF.Business.Claim/clsServiceTypeCollection.vb